**** PROGRAM FILE FOR "INFORMAL VERSUS FORMAL BARGAINING STRUCTURES" PROJECT: RDD MANIPULATION TEST RESULTS ****
 
 
* OPEN STATA OUTPUT FILE LOG *

   log using "C:\Users\gk57526\Dropbox\Informal & Formal Bargaining (BAA Reforms)\JOP Replication File Materials\Output\execbudinfluence.08-26-2020.SI SECTIONS 0 & 2.DESCRIPTIVE STATISTICS & RDD MANIPULATION TESTS.comments.smcl" 



 


 * OPEN "EXECUTIVE BUDGETARY INFLUENCE" DATABASE WITH NEWLY CREATED VARIABLES
 
use "C:\Users\gk57526\Dropbox\Informal & Formal Bargaining (BAA Reforms)\JOP Replication File Materials\Data\execbudinfluence.08-26-2020.REPORTED MODELS.REV.comments.dta", replace

 

*** DECLARE DATABASE AS A PANEL (AGENCY ID * FISCAL YEAR): 

xtset agenid fyear, yearly

*
*
*


 
*** SECTION 0. DESCRIPTIVE STATISTICS BASED ON EFFECTIVE SAMPLE OF DATA (N * T = 665) ***

quietly movestay (congbudchangereg2 l1congbudchangereg2  execbudchangereg2 bureauofbudget ebcreg2baa lnagencyheadtenure baalnaht ebcreg2lnaht ebcreg2baalnaht ///
lnagencyage unifiedpartygovt presadminyear) if agenid!=15, cluster(agenid) select(regimereg = executiveagency) difficult

*

*** TABLE SI-0B [SECTION 0: SUPPORTING INFORMATION DOCUMENT] **

sum execbudchangereg2 execbudchangetot2 congbudchangereg2 congbudchangetot2  regimereg regimetot  bureauofbudget agencyheadtenure    /// 
agencyage  unifiedpartygovt  presadminyear  executiveagency if e(sample)

*




*********************************************************************************************************************************************************************************
*********************************************************************************************************************************************************************************
*********************************************************************************************************************************************************************************
*********************************************************************************************************************************************************************************
*********************************************************************************************************************************************************************************
*********************************************************************************************************************************************************************************
*********************************************************************************************************************************************************************************
*********************************************************************************************************************************************************************************
*********************************************************************************************************************************************************************************
*********************************************************************************************************************************************************************************
*********************************************************************************************************************************************************************************
*********************************************************************************************************************************************************************************



 
*** SECTION 2. REGRESSION DISCONTINUITY DESIGN (RDD) MANIPULATION TESTS EVALUATING 'RANDOMNESS' OF EXECUTIVE BUDGETARY PROPOSALS SURROUNDING E = A DISCONTINUITY POINT ***




*** GENERATE EXECUTIVE BUDGET PROPOSAL - CONGRESSIONAL APPROPRIATION DIFFERENCE VARIABLES ***

generate realexeccongregbuddiff = realexecestreg - realcongappreg
*
generate realexeccongtotbuddiff = realexecesttot - realcongapptot



*** GENERATE EFFECTIVE SAMPLE USED IN ENDOGENEOUS REGIME SWITCHING REGRESSION MODELS ***

quietly movestay (congbudchangereg2 l1congbudchangereg2  execbudchangereg2 bureauofbudget ebcreg2baa lnagencyheadtenure baalnaht ebcreg2lnaht ebcreg2baalnaht ///
lnagencyage unifiedpartygovt presadminyear) if agenid!=15, cluster(agenid) select(regimereg = executiveagency) difficult



*********************************************************************************************************************************************************************************
*********************************************************************************************************************************************************************************
*********************************************************************************************************************************************************************************
*********************************************************************************************************************************************************************************
*********************************************************************************************************************************************************************************



*** TABLE SI-2 [SECTION 2: SUPPORTING INFORMATION DOCUMENT]  ***

 

** TABLE SI-2: [REGULAR BUDGET: FULL SAMPLE] **

rddensity realexeccongregbuddiff if e(sample), all 

*

quietly movestay (congbudchangetot2 l1congbudchangetot2  execbudchangetot2 bureauofbudget ebctot2baa lnagencyheadtenure baalnaht ebctot2lnaht ebctot2baalnaht ///
lnagencyage unifiedpartygovt presadminyear) if agenid!=15, cluster(agenid) select(regimetot = executiveagency) difficult


** TABLE SI-2: [TOTAL BUDGET: FULL SAMPLE] **

rddensity realexeccongtotbuddiff if e(sample), all 

*
*
*

quietly movestay (congbudchangereg2 l1congbudchangereg2  execbudchangereg2 bureauofbudget ebcreg2baa lnagencyheadtenure baalnaht ebcreg2lnaht ebcreg2baalnaht ///
lnagencyage unifiedpartygovt presadminyear) if agenid!=15, cluster(agenid) select(regimereg = executiveagency) difficult


** TABLE SI-2: [REGULAR BUDGET: PRE-BAA REFORM SAMPLE] **

rddensity realexeccongregbuddiff if e(sample) & bureauofbudget==0, all 

*

quietly movestay (congbudchangetot2 l1congbudchangetot2  execbudchangetot2 bureauofbudget ebctot2baa lnagencyheadtenure baalnaht ebctot2lnaht ebctot2baalnaht ///
lnagencyage unifiedpartygovt presadminyear) if agenid!=15, cluster(agenid) select(regimetot = executiveagency) difficult



** TABLE SI-2: [TOTAL BUDGET: PRE-BAA REFORM SAMPLE] **

rddensity realexeccongtotbuddiff if e(sample) & bureauofbudget==0, all 

*
*
*
*

quietly movestay (congbudchangetot2 l1congbudchangetot2  execbudchangetot2 bureauofbudget ebctot2baa lnagencyheadtenure baalnaht ebctot2lnaht ebctot2baalnaht ///
lnagencyage unifiedpartygovt presadminyear) if agenid!=15, cluster(agenid) select(regimetot = executiveagency) difficult


** TABLE SI-2: [REGULAR BUDGET: POST-BAA REFORM SAMPLE] **

rddensity realexeccongregbuddiff if e(sample) & bureauofbudget==1, all 

*

quietly movestay (congbudchangetot2 l1congbudchangetot2  execbudchangetot2 bureauofbudget ebctot2baa lnagencyheadtenure baalnaht ebctot2lnaht ebctot2baalnaht ///
lnagencyage unifiedpartygovt presadminyear) if agenid!=15, cluster(agenid) select(regimetot = executiveagency) difficult


** TABLE SI-2: [TOTAL BUDGET: POST-BAA REFORM SAMPLE] **

rddensity realexeccongtotbuddiff if e(sample) & bureauofbudget==1, all 




*********************************************************************************************************************************************************************************
*********************************************************************************************************************************************************************************
*********************************************************************************************************************************************************************************
*********************************************************************************************************************************************************************************
*********************************************************************************************************************************************************************************
*********************************************************************************************************************************************************************************
*********************************************************************************************************************************************************************************
*********************************************************************************************************************************************************************************
*********************************************************************************************************************************************************************************
*********************************************************************************************************************************************************************************
*********************************************************************************************************************************************************************************
*********************************************************************************************************************************************************************************


save "C:\Users\gk57526\Dropbox\Informal & Formal Bargaining (BAA Reforms)\JOP Replication File Materials\Data\execbudinfluence.08-26-2020.SECTIONS 0&2.comments.dta", replace



log close



